Property starting with A |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Amount
|
Amount
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with B |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
BirthDate
|
BirthDate
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with C |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
CarAcquiredDate
|
CarAcquiredDate
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CarModel
|
CarModel
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CarYear
|
CarYear
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CompanyCode
|
CompanyCode
|
String
|
|
3
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostCenter
|
CostCenter
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CountryCode
|
CountryCode
|
String
|
|
3
|
0
|
MY
|
|
|
|
|
|
|
|
|
|
|
|
CP22AEsosBalance
|
CP22AEsosBalance
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
CP22AEsosEligibleShareAmt
|
CP22AEsosEligibleShareAmt
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
CP22AEsosOptDate
|
CP22AEsosOptDate
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CP22AEsosSkim
|
CP22AEsosSkim
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CP22AExtraPay
|
CP22AExtraPay
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
CP22AExtraPayDate
|
CP22AExtraPayDate
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CP22AExtraPayType
|
CP22AExtraPayType
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CP22APayOnHold
|
CP22APayOnHold
|
Number
|
|
11
|
2
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatedDate
|
Created
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Creator
|
Creator
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
CreatorName
|
CreatorName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreditorNumber
|
CreditorNumber
|
String
|
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with E |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
EmploymentStart
|
EmploymentStart
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
EndDate
|
EndDate
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with F |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
FirstHalfPaymentMethod
|
FirstHalfPaymentMethod
|
String
|
|
1
|
0
|
P
|
|
|
|
|
|
|
|
|
|
|
P,8466,Percentage | A,4182,Amount |
|
Property starting with I |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ID
|
ID
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with M |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ModifiedDate
|
Modified
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
Modifier
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
ModifierName
|
ModifierName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with N |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
NumberOfChildren
|
NumOfChildren
|
Number
|
|
5
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with P |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
PaymentPeriod
|
PaymentPeriod
|
String
|
|
1
|
0
|
M
|
|
|
|
|
|
|
|
|
|
|
M,24003,Monthly | S,0,Semi-monthly | B,30355,Bi-weekly | W,24228,Weekly |
|
PayrollYear
|
PayrollYear
|
String
|
|
4
|
0
|
select stringvalue from settings where settingname='lnjr_std'
|
|
|
|
|
|
|
|
|
|
|
|
Percentage
|
Percentage
|
Number
|
|
8
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
Period
|
Period
|
Number
|
|
3
|
0
|
SELECT TOP 1 LTRIM(per_fin) FROM perdat WHERE bgdatum <= GETDATE() AND eddatum >=GETDATE()
|
|
|
|
|
|
|
|
|
|
|
1,0, 1 | 2,0, 2 | 3,0, 3 | 4,0, 4 | 5,0, 5 | 6,0, 6 | 7,0, 7 | 8,0, 8 | 9,0, 9 | 10,0, 10 | 11,0, 11 | 12,0, 12 |
|
PreviousEmployer
|
PreviousEmployer
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with R |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ResourceCostCenter
|
ResourceCostCenter
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ResourceID
|
ResourceID
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ResourceName
|
ResourceName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with S |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
SocialSecurityNumber
|
SocialSecurityNumber
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SocsoScheme
|
SocsoScheme
|
String
|
|
1
|
0
|
E
|
|
|
|
|
|
|
|
|
|
|
E,0,Employment injury & invalidity | I,0,Employment injury only |
|
StartDate
|
StartDate
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with T |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
TaxBranch
|
TaxBranch
|
String
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
,0, | AS,0,Alor Setar | BI,0,Bintulu | BM,0,Bukit Mertajam | CH,0,Cheras | DU,0,Jalan Duta | IP,0,Ipoh | JB,0,Johor Bahru | KP,0,Kg. Attap | KB,0,Kota Bharu | KC,0,Kuching | KA,0,Kluang | KK,0,Kota Kinabalu | KG,0,Klang | KN,0,Kuantan | KR,0,Kangar | KT,0,Kuala Terengganu | KE,0,Keningau | LA,0,Labuan | ME,0,Melaka | MR,0,Miri | MU,0,Muar | PJ,0,Petaling Jaya | PP,0,Pulau Pinang | RB,0,Raub | SI,0,Sibu | SD,0,Sandakan | SA,0,Shah Alam | SP,0,Sungai Petani | SR,0,Seremban | SY,0,Syarikat | TP,0,Taiping | TW,0,Tawau | TI,0,Teluk Intan | TM,0,Temerloh | TB,0,Tidak bermastatin | WM,0,Wangsa Maju |
|
TaxBranchSpouse
|
TaxBranchSpouse
|
String
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
,0, | AS,0,Alor Setar | BI,0,Bintulu | BM,0,Bukit Mertajam | CH,0,Cheras | DU,0,Jalan Duta | IP,0,Ipoh | JB,0,Johor Bahru | KP,0,Kg. Attap | KB,0,Kota Bharu | KC,0,Kuching | KA,0,Kluang | KK,0,Kota Kinabalu | KG,0,Klang | KN,0,Kuantan | KR,0,Kangar | KT,0,Kuala Terengganu | KE,0,Keningau | LA,0,Labuan | ME,0,Melaka | MR,0,Miri | MU,0,Muar | PJ,0,Petaling Jaya | PP,0,Pulau Pinang | RB,0,Raub | SI,0,Sibu | SD,0,Sandakan | SA,0,Shah Alam | SP,0,Sungai Petani | SR,0,Seremban | SY,0,Syarikat | TP,0,Taiping | TW,0,Tawau | TI,0,Teluk Intan | TM,0,Temerloh | TB,0,Tidak bermastatin | WM,0,Wangsa Maju |
|
TaxCategory
|
TaxCategory
|
String
|
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
1,0,Category 1 - Single | 2,0,Category 2 - Married and spouse not working | 3,0,Category 3 - Married and both are working |
|
TaxExemptionFrom
|
TaxExcemptionFrom
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TaxExemptionTo
|
TaxExcemptionTo
|
Date
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|